<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

/**
 * Class CreateMedicalDisposeTable
 * 病历处理数据库
 */
class CreateMedicalDisposeTable extends Migration
{
    /**
     * Run the migrations.
     * @return void
     */
    public function up()
    {
        Schema::create(
            'st_medical_dispose',
            function (Blueprint $table) {
                $table->increments('id');
                $table->unsignedInteger('record_id')->index()->comment("关联medical_records_id");
                $table->text('control_objectives')->nullable()->comment("控制目标情况");
                $table->text('advise')->nullable()->comment("专科建议");
                $table->text('inspection_plan')->nullable()->comment("检查方案");
                $table->text('schedule')->nullable()->comment("治疗方案,包含建议转诊，治疗方案及处方 西药用药");
                $table->text('cn_medication')->comment("中医汤药");
                $table->string('signatures')->comment("医生电子签名");
                $table->string('remark')->default('')->comment('备注');
                $table->timestamps();
            }
        );
    }

    /**
     * Reverse the migrations.
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('st_medical_dispose');
    }
}
